<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE topic
  PUBLIC "-//OASIS//DTD DITA Composite//EN" "ditabase.dtd">
<topic id="topic1" xml:lang="en">
  <title id="et150574">SQL 2008 Optional Feature Compliance</title>
  <body>
    <p>The following table lists the features described in the 2008 SQL standard. Features that are
      supported in Greenplum Database are marked as YES in the 'Supported' column, features that are
      not implemented are marked as NO.</p>
    <p>For information about Greenplum features and SQL compliance, see the <i>Greenplum Database
        Administrator Guide</i>.</p>
    <table id="et163933">
      <title>SQL 2008 Optional Feature Compliance Details</title>
      <tgroup cols="4">
        <colspec colnum="1" colname="col1" colwidth="46pt"/>
        <colspec colnum="2" colname="col2" colwidth="209pt"/>
        <colspec colnum="3" colname="col3" colwidth="59pt"/>
        <colspec colnum="4" colname="col4" colwidth="133pt"/>
        <thead>
          <row>
            <entry colname="col1">ID</entry>
            <entry colname="col2">Feature</entry>
            <entry colname="col3">Supported</entry>
            <entry colname="col4">Comments</entry>
          </row>
        </thead>
        <tbody>
          <row>
            <entry colname="col1">B011</entry>
            <entry colname="col2">Embedded Ada</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B012</entry>
            <entry colname="col2">Embedded C</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Due to issues with PostgreSQL <codeph>ecpg</codeph></entry>
          </row>
          <row>
            <entry colname="col1">B013</entry>
            <entry colname="col2">Embedded COBOL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B014</entry>
            <entry colname="col2">Embedded Fortran</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B015</entry>
            <entry colname="col2">Embedded MUMPS</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B016</entry>
            <entry colname="col2">Embedded Pascal</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B017</entry>
            <entry colname="col2">Embedded PL/I</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B021</entry>
            <entry colname="col2">Direct SQL</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B031</entry>
            <entry colname="col2">Basic dynamic SQL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B032</entry>
            <entry colname="col2">Extended dynamic SQL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B033</entry>
            <entry colname="col2">Untyped SQL-invoked function arguments</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B034</entry>
            <entry colname="col2">Dynamic specification of cursor attributes</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B035</entry>
            <entry colname="col2">Non-extended descriptor names</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B041</entry>
            <entry colname="col2">Extensions to embedded SQL exception declarations</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B051</entry>
            <entry colname="col2">Enhanced execution rights</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B111</entry>
            <entry colname="col2">Module language Ada</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B112</entry>
            <entry colname="col2">Module language C</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B113</entry>
            <entry colname="col2">Module language COBOL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B114</entry>
            <entry colname="col2">Module language Fortran</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B115</entry>
            <entry colname="col2">Module language MUMPS</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B116</entry>
            <entry colname="col2">Module language Pascal</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B117</entry>
            <entry colname="col2">Module language PL/I</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B121</entry>
            <entry colname="col2">Routine language Ada</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B122</entry>
            <entry colname="col2">Routine language C</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B123</entry>
            <entry colname="col2">Routine language COBOL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B124</entry>
            <entry colname="col2">Routine language Fortran</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B125</entry>
            <entry colname="col2">Routine language MUMPS</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B126</entry>
            <entry colname="col2">Routine language Pascal</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B127</entry>
            <entry colname="col2">Routine language PL/I</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">B128</entry>
            <entry colname="col2">Routine language SQL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E011</entry>
            <entry colname="col2">Numeric data types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E011-01</entry>
            <entry colname="col2"><codeph>INTEGER</codeph> and <codeph>SMALLINT</codeph> data
              types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E011-02</entry>
            <entry colname="col2"><codeph>DOUBLE PRECISION</codeph> and <codeph>FLOAT</codeph> data
              types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E011-03</entry>
            <entry colname="col2"><codeph>DECIMAL</codeph> and <codeph>NUMERIC</codeph> data
              types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E011-04</entry>
            <entry colname="col2">Arithmetic operators</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E011-05</entry>
            <entry colname="col2">Numeric comparison</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E011-06</entry>
            <entry colname="col2">Implicit casting among the numeric data types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021</entry>
            <entry colname="col2">Character data types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-01</entry>
            <entry colname="col2"><codeph>CHARACTER</codeph> data type</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-02</entry>
            <entry colname="col2"><codeph>CHARACTER VARYING</codeph> data type</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-03</entry>
            <entry colname="col2">Character literals</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-04</entry>
            <entry colname="col2"><codeph>CHARACTER_LENGTH</codeph> function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Trims trailing spaces from <codeph>CHARACTER</codeph> values
              before counting</entry>
          </row>
          <row>
            <entry colname="col1">E021-05</entry>
            <entry colname="col2"><codeph>OCTET_LENGTH</codeph> function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-06</entry>
            <entry colname="col2"><codeph>SUBSTRING</codeph> function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-07</entry>
            <entry colname="col2">Character concatenation</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-08</entry>
            <entry colname="col2"><codeph>UPPER</codeph> and <codeph>LOWER</codeph>
              functions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-09</entry>
            <entry colname="col2"><codeph>TRIM</codeph> function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-10</entry>
            <entry colname="col2">Implicit casting among the character string types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-11</entry>
            <entry colname="col2"><codeph>POSITION</codeph> function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E021-12</entry>
            <entry colname="col2">Character comparison</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E031</entry>
            <entry colname="col2">Identifiers</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E031-01</entry>
            <entry colname="col2">Delimited identifiers</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E031-02</entry>
            <entry colname="col2">Lower case identifiers</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E031-03</entry>
            <entry colname="col2">Trailing underscore</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051</entry>
            <entry colname="col2">Basic query specification</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051-01</entry>
            <entry colname="col2">
              <codeph>SELECT DISTINCT</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051-02</entry>
            <entry colname="col2"><codeph>GROUP BY</codeph> clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051-03</entry>
            <entry colname="col2"><codeph>GROUP BY</codeph> can contain columns not in
                <codeph>SELECT</codeph> list</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051-04</entry>
            <entry colname="col2"><codeph>SELECT</codeph> list items can be renamed</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051-05</entry>
            <entry colname="col2"><codeph>HAVING</codeph> clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051-06</entry>
            <entry colname="col2">Qualified * in <codeph>SELECT</codeph> list</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051-07</entry>
            <entry colname="col2">Correlation names in the <codeph>FROM</codeph> clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E051-08</entry>
            <entry colname="col2">Rename columns in the <codeph>FROM</codeph> clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061</entry>
            <entry colname="col2">Basic predicates and search conditions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-01</entry>
            <entry colname="col2">Comparison predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-02</entry>
            <entry colname="col2"><codeph>BETWEEN</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-03</entry>
            <entry colname="col2"><codeph>IN</codeph> predicate with list of values</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-04</entry>
            <entry colname="col2"><codeph>LIKE</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-05</entry>
            <entry colname="col2"><codeph>LIKE</codeph> predicate <codeph>ESCAPE</codeph>
              clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-06</entry>
            <entry colname="col2"><codeph>NULL</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-07</entry>
            <entry colname="col2">Quantified comparison predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-08</entry>
            <entry colname="col2"><codeph>EXISTS</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Not all uses work in Greenplum</entry>
          </row>
          <row>
            <entry colname="col1">E061-09</entry>
            <entry colname="col2">Subqueries in comparison predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-11</entry>
            <entry colname="col2">Subqueries in IN predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-12</entry>
            <entry colname="col2">Subqueries in quantified comparison predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-13</entry>
            <entry colname="col2">Correlated subqueries</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E061-14</entry>
            <entry colname="col2">Search condition</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E071</entry>
            <entry colname="col2">Basic query expressions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E071-01</entry>
            <entry colname="col2"><codeph>UNION DISTINCT</codeph> table operator</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E071-02</entry>
            <entry colname="col2"><codeph>UNION ALL</codeph> table operator</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E071-03</entry>
            <entry colname="col2"><codeph>EXCEPT DISTINCT</codeph> table operator</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E071-05</entry>
            <entry colname="col2">Columns combined via table operators need not have exactly the
              same data type</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E071-06</entry>
            <entry colname="col2">Table operators in subqueries</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081</entry>
            <entry colname="col2">Basic Privileges</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Partial sub-feature support</entry>
          </row>
          <row>
            <entry colname="col1">E081-01</entry>
            <entry colname="col2"><codeph>SELECT</codeph> privilege</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-02</entry>
            <entry colname="col2"><codeph>DELETE</codeph> privilege</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-03</entry>
            <entry colname="col2"><codeph>INSERT</codeph> privilege at the table level</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-04</entry>
            <entry colname="col2"><codeph>UPDATE</codeph> privilege at the table level</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-05</entry>
            <entry colname="col2"><codeph>UPDATE</codeph> privilege at the column level</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-06</entry>
            <entry colname="col2"><codeph>REFERENCES</codeph> privilege at the table level</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-07</entry>
            <entry colname="col2"><codeph>REFERENCES</codeph> privilege at the column level</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-08</entry>
            <entry colname="col2">
              <codeph>WITH GRANT OPTION</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-09</entry>
            <entry colname="col2"><codeph>USAGE</codeph> privilege</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E081-10</entry>
            <entry colname="col2"><codeph>EXECUTE</codeph> privilege</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E091</entry>
            <entry colname="col2">Set Functions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E091-01</entry>
            <entry colname="col2">
              <codeph>AVG</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E091-02</entry>
            <entry colname="col2">
              <codeph>COUNT</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E091-03</entry>
            <entry colname="col2">
              <codeph>MAX</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E091-04</entry>
            <entry colname="col2">
              <codeph>MIN</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E091-05</entry>
            <entry colname="col2">
              <codeph>SUM</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E091-06</entry>
            <entry colname="col2"><codeph>ALL</codeph> quantifier</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E091-07</entry>
            <entry colname="col2"><codeph>DISTINCT</codeph> quantifier</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E101</entry>
            <entry colname="col2">Basic data manipulation</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E101-01</entry>
            <entry colname="col2"><codeph>INSERT</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E101-03</entry>
            <entry colname="col2">Searched <codeph>UPDATE</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E101-04</entry>
            <entry colname="col2">Searched <codeph>DELETE</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E111</entry>
            <entry colname="col2">Single row <codeph>SELECT</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121</entry>
            <entry colname="col2">Basic cursor support</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-01</entry>
            <entry colname="col2">
              <codeph>DECLARE CURSOR</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-02</entry>
            <entry colname="col2"><codeph>ORDER BY</codeph> columns need not be in select
              list</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-03</entry>
            <entry colname="col2">Value expressions in <codeph>ORDER BY</codeph> clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-04</entry>
            <entry colname="col2"><codeph>OPEN</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-06</entry>
            <entry colname="col2">Positioned <codeph>UPDATE</codeph> statement</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-07</entry>
            <entry colname="col2">Positioned <codeph>DELETE</codeph> statement</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-08</entry>
            <entry colname="col2"><codeph>CLOSE</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-10</entry>
            <entry colname="col2"><codeph>FETCH</codeph> statement implicit
              <codeph>NEXT</codeph></entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E121-17</entry>
            <entry colname="col2"><codeph>WITH HOLD</codeph> cursors</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E131</entry>
            <entry colname="col2">Null value support</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E141</entry>
            <entry colname="col2">Basic integrity constraints</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E141-01</entry>
            <entry colname="col2"><codeph>NOT NULL</codeph> constraints</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E141-02</entry>
            <entry colname="col2"><codeph>UNIQUE</codeph> constraints of <codeph>NOT NULL</codeph>
              columns</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Must be the same as or a superset of the Greenplum distribution
              key</entry>
          </row>
          <row>
            <entry colname="col1">E141-03</entry>
            <entry colname="col2"><codeph>PRIMARY KEY</codeph> constraints</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Must be the same as or a superset of the Greenplum distribution
              key</entry>
          </row>
          <row>
            <entry colname="col1">E141-04</entry>
            <entry colname="col2">Basic <codeph>FOREIGN KEY</codeph> constraint with the <codeph>NO
                ACTION</codeph> default for both referential delete action and referential update
              action</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E141-06</entry>
            <entry colname="col2"><codeph>CHECK</codeph> constraints</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E141-07</entry>
            <entry colname="col2">Column defaults</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E141-08</entry>
            <entry colname="col2"><codeph>NOT NULL</codeph> inferred on <codeph>PRIMARY
              KEY</codeph></entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E141-10</entry>
            <entry colname="col2">Names in a foreign key can be specified in any order</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Foreign keys can be declared but are not enforced in
              Greenplum</entry>
          </row>
          <row>
            <entry colname="col1">E151</entry>
            <entry colname="col2">Transaction support</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E151-01</entry>
            <entry colname="col2"><codeph>COMMIT</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E151-02</entry>
            <entry colname="col2"><codeph>ROLLBACK</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E152</entry>
            <entry colname="col2">Basic SET TRANSACTION statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E152-01</entry>
            <entry colname="col2"><codeph>ISOLATION LEVEL SERIALIZABLE</codeph> clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Can be declared but is treated as a synonym for <codeph>REPEATABLE
                READ</codeph></entry>
          </row>
          <row>
            <entry colname="col1">E152-02</entry>
            <entry colname="col2"><codeph>READ ONLY</codeph> and <codeph>READ WRITE</codeph>
              clauses</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E153</entry>
            <entry colname="col2">Updatable queries with subqueries</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E161</entry>
            <entry colname="col2">SQL comments using leading double minus</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E171</entry>
            <entry colname="col2">SQLSTATE support</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">E182</entry>
            <entry colname="col2">Module language</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F021</entry>
            <entry colname="col2">Basic information schema</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F021-01</entry>
            <entry colname="col2"><codeph>COLUMNS</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F021-02</entry>
            <entry colname="col2"><codeph>TABLES</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F021-03</entry>
            <entry colname="col2"><codeph>VIEWS</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F021-04</entry>
            <entry colname="col2"><codeph>TABLE_CONSTRAINTS</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F021-05</entry>
            <entry colname="col2"><codeph>REFERENTIAL_CONSTRAINTS</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F021-06</entry>
            <entry colname="col2"><codeph>CHECK_CONSTRAINTS</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F031</entry>
            <entry colname="col2">Basic schema manipulation</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F031-01</entry>
            <entry colname="col2"><codeph>CREATE TABLE</codeph> statement to create persistent base
              tables</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F031-02</entry>
            <entry colname="col2"><codeph>CREATE VIEW</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F031-03</entry>
            <entry colname="col2"><codeph>GRANT</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F031-04</entry>
            <entry colname="col2"><codeph>ALTER TABLE</codeph> statement: <codeph>ADD
                COLUMN</codeph> clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F031-13</entry>
            <entry colname="col2"><codeph>DROP TABLE</codeph> statement: <codeph>RESTRICT</codeph>
              clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F031-16</entry>
            <entry colname="col2"><codeph>DROP VIEW</codeph> statement: <codeph>RESTRICT</codeph>
              clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F031-19</entry>
            <entry colname="col2"><codeph>REVOKE</codeph> statement: <codeph>RESTRICT</codeph>
              clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F032</entry>
            <entry colname="col2"><codeph>CASCADE</codeph> drop behavior</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F033</entry>
            <entry colname="col2"><codeph>ALTER TABLE</codeph> statement: <codeph>DROP
                COLUMN</codeph> clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F034</entry>
            <entry colname="col2">Extended REVOKE statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F034-01</entry>
            <entry colname="col2"><codeph>REVOKE</codeph> statement performed by other than the
              owner of a schema object</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F034-02</entry>
            <entry colname="col2"><codeph>REVOKE</codeph> statement: <codeph>GRANT OPTION
                FOR</codeph> clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F034-03</entry>
            <entry colname="col2"><codeph>REVOKE</codeph> statement to revoke a privilege that the
              grantee has <codeph>WITH GRANT OPTION</codeph></entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F041</entry>
            <entry colname="col2">Basic joined table</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F041-01</entry>
            <entry colname="col2">Inner join (but not necessarily the <codeph>INNER</codeph>
              keyword)</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F041-02</entry>
            <entry colname="col2"><codeph>INNER</codeph> keyword</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F041-03</entry>
            <entry colname="col2">
              <codeph>LEFT OUTER JOIN</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F041-04</entry>
            <entry colname="col2">
              <codeph>RIGHT OUTER JOIN</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F041-05</entry>
            <entry colname="col2">Outer joins can be nested</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F041-07</entry>
            <entry colname="col2">The inner table in a left or right outer join can also be used in
              an inner join</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F041-08</entry>
            <entry colname="col2">All comparison operators are supported (rather than just
                <codeph>=</codeph>)</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051</entry>
            <entry colname="col2">Basic date and time</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051-01</entry>
            <entry colname="col2"><codeph>DATE</codeph> data type (including support of
                <codeph>DATE</codeph> literal)</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051-02</entry>
            <entry colname="col2"><codeph>TIME</codeph> data type (including support of
                <codeph>TIME</codeph> literal) with fractional seconds precision of at least
              0</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051-03</entry>
            <entry colname="col2"><codeph>TIMESTAMP</codeph> data type (including support of
                <codeph>TIMESTAMP</codeph> literal) with fractional seconds precision of at least 0
              and 6</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051-04</entry>
            <entry colname="col2">Comparison predicate on <codeph>DATE</codeph>,
                <codeph>TIME</codeph>, and <codeph>TIMESTAMP</codeph> data types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051-05</entry>
            <entry colname="col2">Explicit <codeph>CAST</codeph> between datetime types and
              character string types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051-06</entry>
            <entry colname="col2">
              <codeph>CURRENT_DATE</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051-07</entry>
            <entry colname="col2">
              <codeph>LOCALTIME</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F051-08</entry>
            <entry colname="col2">
              <codeph>LOCALTIMESTAMP</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F052</entry>
            <entry colname="col2">Intervals and datetime arithmetic</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F053</entry>
            <entry colname="col2"><codeph>OVERLAPS</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F081</entry>
            <entry colname="col2"><codeph>UNION</codeph> and <codeph>EXCEPT</codeph> in
              views</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F111</entry>
            <entry colname="col2">Isolation levels other than SERIALIZABLE</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F111-01</entry>
            <entry colname="col2"><codeph>READ UNCOMMITTED </codeph>isolation level</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Can be declared but is treated as a synonym for <codeph>READ
                COMMITTED</codeph></entry>
          </row>
          <row>
            <entry colname="col1">F111-02</entry>
            <entry colname="col2"><codeph>READ COMMITTED</codeph> isolation level</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F111-03</entry>
            <entry colname="col2"><codeph>REPEATABLE READ</codeph> isolation level</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"> </entry>
          </row>
          <row>
            <entry colname="col1">F121</entry>
            <entry colname="col2">Basic diagnostics management</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F122</entry>
            <entry colname="col2">Enhanced diagnostics management</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F123</entry>
            <entry colname="col2">All diagnostics</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F131-</entry>
            <entry colname="col2">Grouped operations</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F131-01</entry>
            <entry colname="col2"><codeph>WHERE</codeph>, <codeph>GROUP BY</codeph>, and
                <codeph>HAVING</codeph> clauses supported in queries with grouped views</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F131-02</entry>
            <entry colname="col2">Multiple tables supported in queries with grouped views</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F131-03</entry>
            <entry colname="col2">Set functions supported in queries with grouped views</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F131-04</entry>
            <entry colname="col2">Subqueries with <codeph>GROUP BY</codeph> and
                <codeph>HAVING</codeph> clauses and grouped views</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F131-05</entry>
            <entry colname="col2">Single row <codeph>SELECT</codeph> with <codeph>GROUP BY</codeph>
              and <codeph>HAVING</codeph> clauses and grouped views</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F171</entry>
            <entry colname="col2">Multiple schemas per user</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F181</entry>
            <entry colname="col2">Multiple module support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F191</entry>
            <entry colname="col2">Referential delete actions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F200</entry>
            <entry colname="col2"><codeph>TRUNCATE TABLE</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F201</entry>
            <entry colname="col2"><codeph>CAST</codeph> function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F202</entry>
            <entry colname="col2"><codeph>TRUNCATE TABLE</codeph>: identity column restart
              option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F221</entry>
            <entry colname="col2">Explicit defaults</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F222</entry>
            <entry colname="col2"><codeph>INSERT</codeph> statement: <codeph>DEFAULT VALUES</codeph>
              clause</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F231</entry>
            <entry colname="col2">Privilege tables</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F231-01</entry>
            <entry colname="col2"><codeph>TABLE_PRIVILEGES</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F231-02</entry>
            <entry colname="col2"><codeph>COLUMN_PRIVILEGES</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F231-03</entry>
            <entry colname="col2"><codeph>USAGE_PRIVILEGES</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F251</entry>
            <entry colname="col2">Domain support</entry>
            <entry colname="col3"/>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F261</entry>
            <entry colname="col2">CASE expression</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F261-01</entry>
            <entry colname="col2">Simple <codeph>CASE</codeph></entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F261-02</entry>
            <entry colname="col2">Searched <codeph>CASE</codeph></entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F261-03</entry>
            <entry colname="col2">
              <codeph>NULLIF</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F261-04</entry>
            <entry colname="col2">
              <codeph>COALESCE</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F262</entry>
            <entry colname="col2">Extended <codeph>CASE</codeph> expression</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F263</entry>
            <entry colname="col2">Comma-separated predicates in simple <codeph>CASE</codeph>
              expression</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F271</entry>
            <entry colname="col2">Compound character literals</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F281</entry>
            <entry colname="col2"><codeph>LIKE</codeph> enhancements</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F291</entry>
            <entry colname="col2"><codeph>UNIQUE</codeph> predicate</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F301</entry>
            <entry colname="col2"><codeph>CORRESPONDING </codeph>in query expressions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F302</entry>
            <entry colname="col2">INTERSECT table operator</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F302-01</entry>
            <entry colname="col2"><codeph>INTERSECT DISTINCT</codeph> table operator</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F302-02</entry>
            <entry colname="col2"><codeph>INTERSECT ALL</codeph> table operator</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F304</entry>
            <entry colname="col2"><codeph>EXCEPT ALL</codeph> table operator</entry>
            <entry colname="col3"/>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F311</entry>
            <entry colname="col2">Schema definition statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Partial sub-feature support</entry>
          </row>
          <row>
            <entry colname="col1">F311-01</entry>
            <entry colname="col2">
              <codeph>CREATE SCHEMA</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F311-02</entry>
            <entry colname="col2"><codeph>CREATE TABLE</codeph> for persistent base tables</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F311-03</entry>
            <entry colname="col2">
              <codeph>CREATE VIEW</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F311-04</entry>
            <entry colname="col2">
              <codeph>CREATE VIEW: WITH CHECK OPTION</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F311-05</entry>
            <entry colname="col2"><codeph>GRANT</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F312</entry>
            <entry colname="col2"><codeph>MERGE</codeph> statement</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F313</entry>
            <entry colname="col2">Enhanced <codeph>MERGE</codeph> statement</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F321</entry>
            <entry colname="col2">User authorization</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F341</entry>
            <entry colname="col2">Usage Tables</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F361</entry>
            <entry colname="col2">Subprogram support</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F381</entry>
            <entry colname="col2">Extended schema manipulation</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F381-01</entry>
            <entry colname="col2"><codeph>ALTER TABLE</codeph> statement: <codeph>ALTER
                COLUMN</codeph> clause</entry>
            <entry colname="col3"/>
            <entry colname="col4">Some limitations on altering distribution key columns</entry>
          </row>
          <row>
            <entry colname="col1">F381-02</entry>
            <entry colname="col2"><codeph>ALTER TABLE</codeph> statement: <codeph>ADD
                CONSTRAINT</codeph> clause</entry>
            <entry colname="col3"/>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F381-03</entry>
            <entry colname="col2"><codeph>ALTER TABLE</codeph> statement: <codeph>DROP
                CONSTRAINT</codeph> clause</entry>
            <entry colname="col3"/>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F382</entry>
            <entry colname="col2">Alter column data type</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Some limitations on altering distribution key columns</entry>
          </row>
          <row>
            <entry colname="col1">F391</entry>
            <entry colname="col2">Long identifiers</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F392</entry>
            <entry colname="col2">Unicode escapes in identifiers</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F393</entry>
            <entry colname="col2">Unicode escapes in literals</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F394</entry>
            <entry colname="col2">Optional normal form specification</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F401</entry>
            <entry colname="col2">Extended joined table</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F401-01</entry>
            <entry colname="col2">
              <codeph>NATURAL JOIN</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F401-02</entry>
            <entry colname="col2">
              <codeph>FULL OUTER JOIN</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F401-04</entry>
            <entry colname="col2">
              <codeph>CROSS JOIN</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F402</entry>
            <entry colname="col2">Named column joins for LOBs, arrays, and multisets</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F403</entry>
            <entry colname="col2">Partitioned joined tables</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F411</entry>
            <entry colname="col2">Time zone specification</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Differences regarding literal interpretation</entry>
          </row>
          <row>
            <entry colname="col1">F421</entry>
            <entry colname="col2">National character</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F431</entry>
            <entry colname="col2">Read-only scrollable cursors</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Forward scrolling only</entry>
          </row>
          <row>
            <entry colname="col1">01</entry>
            <entry colname="col2"><codeph>FETCH</codeph> with explicit <codeph>NEXT</codeph></entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">02</entry>
            <entry colname="col2">
              <codeph>FETCH FIRST</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">03</entry>
            <entry colname="col2">
              <codeph>FETCH LAST</codeph>
            </entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">04</entry>
            <entry colname="col2">
              <codeph>FETCH PRIOR</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">05</entry>
            <entry colname="col2">
              <codeph>FETCH ABSOLUTE</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">06</entry>
            <entry colname="col2">
              <codeph>FETCH RELATIVE</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F441</entry>
            <entry colname="col2">Extended set function support</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F442</entry>
            <entry colname="col2">Mixed column references in set functions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F451</entry>
            <entry colname="col2">Character set definition</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F461</entry>
            <entry colname="col2">Named character sets</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F471</entry>
            <entry colname="col2">Scalar subquery values</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F481</entry>
            <entry colname="col2">Expanded <codeph>NULL</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F491</entry>
            <entry colname="col2">Constraint management</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F501</entry>
            <entry colname="col2">Features and conformance views</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F501-01</entry>
            <entry colname="col2"><codeph>SQL_FEATURES</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F501-02</entry>
            <entry colname="col2"><codeph>SQL_SIZING</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F501-03</entry>
            <entry colname="col2"><codeph>SQL_LANGUAGES</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F502</entry>
            <entry colname="col2">Enhanced documentation tables</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F502-01</entry>
            <entry colname="col2"><codeph>SQL_SIZING_PROFILES</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F502-02</entry>
            <entry colname="col2"><codeph>SQL_IMPLEMENTATION_INFO</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F502-03</entry>
            <entry colname="col2"><codeph>SQL_PACKAGES</codeph> view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F521</entry>
            <entry colname="col2">Assertions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F531</entry>
            <entry colname="col2">Temporary tables</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">Non-standard form</entry>
          </row>
          <row>
            <entry colname="col1">F555</entry>
            <entry colname="col2">Enhanced seconds precision</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F561</entry>
            <entry colname="col2">Full value expressions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F571</entry>
            <entry colname="col2">Truth value tests</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F591</entry>
            <entry colname="col2">Derived tables</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F611</entry>
            <entry colname="col2">Indicator data types</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F641</entry>
            <entry colname="col2">Row and table constructors</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F651</entry>
            <entry colname="col2">Catalog name qualifiers</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F661</entry>
            <entry colname="col2">Simple tables</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F671</entry>
            <entry colname="col2">Subqueries in <codeph>CHECK</codeph></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Intentionally omitted</entry>
          </row>
          <row>
            <entry colname="col1">F672</entry>
            <entry colname="col2">Retrospective check constraints</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F690</entry>
            <entry colname="col2">Collation support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F692</entry>
            <entry colname="col2">Enhanced collation support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F693</entry>
            <entry colname="col2">SQL-session and client module collations</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F695</entry>
            <entry colname="col2">Translation support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F696</entry>
            <entry colname="col2">Additional translation documentation</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F701</entry>
            <entry colname="col2">Referential update actions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F711</entry>
            <entry colname="col2"><codeph>ALTER</codeph> domain</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F721</entry>
            <entry colname="col2">Deferrable constraints</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F731</entry>
            <entry colname="col2"><codeph>INSERT</codeph> column privileges</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F741</entry>
            <entry colname="col2">Referential <codeph>MATCH</codeph> types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">No partial match</entry>
          </row>
          <row>
            <entry colname="col1">F751</entry>
            <entry colname="col2">View <codeph>CHECK</codeph> enhancements</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F761</entry>
            <entry colname="col2">Session management</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F762</entry>
            <entry colname="col2">
              <codeph>CURRENT_CATALOG</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F763</entry>
            <entry colname="col2">
              <codeph>CURRENT_SCHEMA</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F771</entry>
            <entry colname="col2">Connection management</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F781</entry>
            <entry colname="col2">Self-referencing operations</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F791</entry>
            <entry colname="col2">Insensitive cursors</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F801</entry>
            <entry colname="col2">Full set function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F812</entry>
            <entry colname="col2">Basic flagging</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F813</entry>
            <entry colname="col2">Extended flagging</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F831</entry>
            <entry colname="col2">Full cursor update</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F841</entry>
            <entry colname="col2"><codeph>LIKE_REGEX</codeph> predicate</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Non-standard syntax for regex</entry>
          </row>
          <row>
            <entry colname="col1">F842</entry>
            <entry colname="col2"><codeph>OCCURENCES_REGEX</codeph> function</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F843</entry>
            <entry colname="col2"><codeph>POSITION_REGEX</codeph> function</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F844</entry>
            <entry colname="col2"><codeph>SUBSTRING_REGEX </codeph>function</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F845</entry>
            <entry colname="col2"><codeph>TRANSLATE_REGEX</codeph> function</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F846</entry>
            <entry colname="col2">Octet support in regular expression operators</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F847</entry>
            <entry colname="col2">Nonconstant regular expressions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F850</entry>
            <entry colname="col2">Top-level <codeph>ORDER BY</codeph> clause in <i>query
                expression</i></entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F851</entry>
            <entry colname="col2">Top-level <codeph>ORDER BY</codeph> clause in subqueries</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F852</entry>
            <entry colname="col2">Top-level <codeph>ORDER BY</codeph> clause in views</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F855</entry>
            <entry colname="col2">Nested <codeph>ORDER BY</codeph> clause in <i>query
              expression</i></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F856</entry>
            <entry colname="col2">Nested <codeph>FETCH FIRST </codeph>clause in <i>query
                expression</i></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F857</entry>
            <entry colname="col2">Top-level <codeph>FETCH FIRST </codeph>clause in <i>query
                expression</i></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F858</entry>
            <entry colname="col2"><codeph>FETCH FIRST </codeph>clause in subqueries</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F859</entry>
            <entry colname="col2">Top-level <codeph>FETCH FIRST </codeph>clause in views</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F860</entry>
            <entry colname="col2"><codeph>FETCH FIRST ROW</codeph><i>count</i> in <codeph>FETCH
                FIRST</codeph> clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F861</entry>
            <entry colname="col2">Top-level <codeph>RESULT OFFSET</codeph> clause in <i>query
                expression</i></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F862</entry>
            <entry colname="col2"><codeph>RESULT OFFSET</codeph> clause in subqueries</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F863</entry>
            <entry colname="col2">Nested <codeph>RESULT OFFSET</codeph> clause in <i>query
                expression</i></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F864</entry>
            <entry colname="col2">Top-level <codeph>RESULT OFFSET</codeph> clause in views</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">F865</entry>
            <entry colname="col2"><codeph>OFFSET ROW</codeph><i>count</i> in <codeph>RESULT
                OFFSET</codeph> clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S011</entry>
            <entry colname="col2">Distinct data types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S023</entry>
            <entry colname="col2">Basic structured types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S024</entry>
            <entry colname="col2">Enhanced structured types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S025</entry>
            <entry colname="col2">Final structured types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S026</entry>
            <entry colname="col2">Self-referencing structured types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S027</entry>
            <entry colname="col2">Create method by specific method name</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S028</entry>
            <entry colname="col2">Permutable UDT options list</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S041</entry>
            <entry colname="col2">Basic reference types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S043</entry>
            <entry colname="col2">Enhanced reference types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S051</entry>
            <entry colname="col2">Create table of type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S071</entry>
            <entry colname="col2">SQL paths in function and type name resolution</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S091</entry>
            <entry colname="col2">Basic array support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Greenplum has arrays, but is not fully standards compliant</entry>
          </row>
          <row>
            <entry colname="col1">S091-01</entry>
            <entry colname="col2">Arrays of built-in data types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Partially compliant</entry>
          </row>
          <row>
            <entry colname="col1">S091-02</entry>
            <entry colname="col2">Arrays of distinct types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S091-03</entry>
            <entry colname="col2">Array expressions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S092</entry>
            <entry colname="col2">Arrays of user-defined types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S094</entry>
            <entry colname="col2">Arrays of reference types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S095</entry>
            <entry colname="col2">Array constructors by query</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S096</entry>
            <entry colname="col2">Optional array bounds</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S097</entry>
            <entry colname="col2">Array element assignment</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S098</entry>
            <entry colname="col2">
              <codeph>ARRAY_AGG</codeph>
            </entry>
            <entry colname="col3">Partially</entry>
            <entry colname="col4">Supported: Using array_agg without a window specification; for
                example<p>SELECT array_agg(x) FROM ...</p><p>SELECT array_agg (x order by y) FROM
                ...</p><p>Not supported: Using array_agg as an aggregate derived window function;
                for example</p><p>SELECT array_agg(x) over (ORDER BY y) FROM ...</p><p>SELECT
                array_agg(x order by y) over (PARTITION BY z) FROM ...</p><p>SELECT array_agg(x
                order by y) over (ORDER BY z) FROM ...</p></entry>
          </row>
          <row>
            <entry colname="col1">S111</entry>
            <entry colname="col2"><codeph>ONLY</codeph> in query expressions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S151</entry>
            <entry colname="col2">Type predicate</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S161</entry>
            <entry colname="col2">Subtype treatment</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S162</entry>
            <entry colname="col2">Subtype treatment for references</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S201</entry>
            <entry colname="col2">SQL-invoked routines on arrays</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Functions can be passed Greenplum array types</entry>
          </row>
          <row>
            <entry colname="col1">S202</entry>
            <entry colname="col2">SQL-invoked routines on multisets</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S211</entry>
            <entry colname="col2">User-defined cast functions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S231</entry>
            <entry colname="col2">Structured type locators</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S232</entry>
            <entry colname="col2">Array locators</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S233</entry>
            <entry colname="col2">Multiset locators</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S241</entry>
            <entry colname="col2">Transform functions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S242</entry>
            <entry colname="col2">Alter transform statement</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S251</entry>
            <entry colname="col2">User-defined orderings</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S261</entry>
            <entry colname="col2">Specific type method</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S271</entry>
            <entry colname="col2">Basic multiset support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S272</entry>
            <entry colname="col2">Multisets of user-defined types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S274</entry>
            <entry colname="col2">Multisets of reference types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S275</entry>
            <entry colname="col2">Advanced multiset support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S281</entry>
            <entry colname="col2">Nested collection types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S291</entry>
            <entry colname="col2">Unique constraint on entire row</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S301</entry>
            <entry colname="col2">Enhanced <codeph>UNNEST</codeph></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S401</entry>
            <entry colname="col2">Distinct types based on array types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S402</entry>
            <entry colname="col2">Distinct types based on distinct types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S403</entry>
            <entry colname="col2">
              <codeph>MAX_CARDINALITY</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">S404</entry>
            <entry colname="col2">
              <codeph>TRIM_ARRAY</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T011</entry>
            <entry colname="col2">Timestamp in Information Schema</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T021</entry>
            <entry colname="col2"><codeph>BINARY</codeph> and <codeph>VARBINARY </codeph>data
              types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T022</entry>
            <entry colname="col2">Advanced support for <codeph>BINARY</codeph> and
                <codeph>VARBINARY</codeph> data types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T023</entry>
            <entry colname="col2">Compound binary literal</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T024</entry>
            <entry colname="col2">Spaces in binary literals</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T031</entry>
            <entry colname="col2"><codeph>BOOLEAN</codeph> data type</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T041</entry>
            <entry colname="col2">Basic <codeph>LOB</codeph> data type support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T042</entry>
            <entry colname="col2">Extended <codeph>LOB</codeph> data type support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T043</entry>
            <entry colname="col2">Multiplier T</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T044</entry>
            <entry colname="col2">Multiplier P</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T051</entry>
            <entry colname="col2">Row types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T052</entry>
            <entry colname="col2"><codeph>MAX</codeph> and <codeph>MIN</codeph> for row
              types</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T053</entry>
            <entry colname="col2">Explicit aliases for all-fields reference</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T061</entry>
            <entry colname="col2">UCS support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T071</entry>
            <entry colname="col2"><codeph>BIGINT</codeph> data type</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T101</entry>
            <entry colname="col2">Enhanced nullability determiniation</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T111</entry>
            <entry colname="col2">Updatable joins, unions, and columns</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T121</entry>
            <entry colname="col2"><codeph>WITH</codeph> (excluding <codeph>RECURSIVE</codeph>) in
              query expression</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T122</entry>
            <entry colname="col2"><codeph>WITH</codeph> (excluding <codeph>RECURSIVE</codeph>) in
              subquery</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T131</entry>
            <entry colname="col2">Recursive query</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T132</entry>
            <entry colname="col2">Recursive query in subquery</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T141</entry>
            <entry colname="col2"><codeph>SIMILAR</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T151</entry>
            <entry colname="col2"><codeph>DISTINCT</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T152</entry>
            <entry colname="col2"><codeph>DISTINCT</codeph> predicate with negation</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T171</entry>
            <entry colname="col2"><codeph>LIKE</codeph> clause in table definition</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T172</entry>
            <entry colname="col2"><codeph>AS</codeph> subquery clause in table definition</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T173</entry>
            <entry colname="col2">Extended <codeph>LIKE</codeph> clause in table definition</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T174</entry>
            <entry colname="col2">Identity columns</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T175</entry>
            <entry colname="col2">Generated columns</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T176</entry>
            <entry colname="col2">Sequence generator support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T177</entry>
            <entry colname="col2">Sequence generator support: simple restart option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T178</entry>
            <entry colname="col2">Identity columns: simple restart option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T191</entry>
            <entry colname="col2">Referential action <codeph>RESTRICT</codeph></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T201</entry>
            <entry colname="col2">Comparable data types for referential constraints</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211</entry>
            <entry colname="col2">Basic trigger capability</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211-01</entry>
            <entry colname="col2">Triggers activated on <codeph>UPDATE</codeph>,
                <codeph>INSERT</codeph>, or <codeph>DELETE</codeph> of one base table</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211-02</entry>
            <entry colname="col2"><codeph>BEFORE</codeph> triggers</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211-03</entry>
            <entry colname="col2"><codeph>AFTER</codeph> triggers</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211-04</entry>
            <entry colname="col2"><codeph>FOR EACH ROW</codeph> triggers</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211-05</entry>
            <entry colname="col2">Ability to specify a search condition that must be true before the
              trigger is invoked</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211-06</entry>
            <entry colname="col2">Support for run-time rules for the interaction of triggers and
              constraints</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211-07</entry>
            <entry colname="col2"><codeph>TRIGGER</codeph> privilege</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T211-08</entry>
            <entry colname="col2">Multiple triggers for the same event are run in the order in
              which they were created in the catalog</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Intentionally omitted</entry>
          </row>
          <row>
            <entry colname="col1">T212</entry>
            <entry colname="col2">Enhanced trigger capability</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T213</entry>
            <entry colname="col2"><codeph>INSTEAD OF</codeph> triggers</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T231</entry>
            <entry colname="col2">Sensitive cursors</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T241</entry>
            <entry colname="col2"><codeph>START TRANSACTION</codeph> statement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T251</entry>
            <entry colname="col2"><codeph>SET TRANSACTION</codeph> statement: <codeph>LOCAL</codeph>
              option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T261</entry>
            <entry colname="col2">Chained transactions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T271</entry>
            <entry colname="col2">Savepoints</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T272</entry>
            <entry colname="col2">Enhanced savepoint management</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T281</entry>
            <entry colname="col2"><codeph>SELECT</codeph> privilege with column granularity</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T285</entry>
            <entry colname="col2">Enhanced derived column names</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T301</entry>
            <entry colname="col2">Functional dependencies</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T312</entry>
            <entry colname="col2">OVERLAY function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T321</entry>
            <entry colname="col2">Basic SQL-invoked routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Partial support</entry>
          </row>
          <row>
            <entry colname="col1">T321-01</entry>
            <entry colname="col2">User-defined functions with no overloading</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T321-02</entry>
            <entry colname="col2">User-defined stored procedures with no overloading</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T321-03</entry>
            <entry colname="col2">Function invocation</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T321-04</entry>
            <entry colname="col2">CALL statement</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T321-05</entry>
            <entry colname="col2">RETURN statement</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T321-06</entry>
            <entry colname="col2">ROUTINES view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T321-07</entry>
            <entry colname="col2">PARAMETERS view</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T322</entry>
            <entry colname="col2">Overloading of SQL-invoked functions and procedures</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T323</entry>
            <entry colname="col2">Explicit security for external routines</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T324</entry>
            <entry colname="col2">Explicit security for SQL routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T325</entry>
            <entry colname="col2">Qualified SQL parameter references</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T326</entry>
            <entry colname="col2">Table functions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T331</entry>
            <entry colname="col2">Basic roles</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T332</entry>
            <entry colname="col2">Extended roles</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T351</entry>
            <entry colname="col2">Bracketed SQL comments (<codeph>/*...*/</codeph> comments)</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T431</entry>
            <entry colname="col2">Extended grouping capabilities</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T432</entry>
            <entry colname="col2">Nested and concatenated <codeph>GROUPING SETS</codeph></entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T433</entry>
            <entry colname="col2">Multiargument <codeph>GROUPING</codeph> function</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T434</entry>
            <entry colname="col2">
              <codeph>GROUP BY DISTINCT</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T441</entry>
            <entry colname="col2"><codeph>ABS</codeph> and <codeph>MOD</codeph> functions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T461</entry>
            <entry colname="col2">Symmetric <codeph>BETWEEN</codeph> predicate</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T471</entry>
            <entry colname="col2">Result sets return value</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T491</entry>
            <entry colname="col2"><codeph>LATERAL</codeph> derived table</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T501</entry>
            <entry colname="col2">Enhanced <codeph>EXISTS</codeph> predicate</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T511</entry>
            <entry colname="col2">Transaction counts</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T541</entry>
            <entry colname="col2">Updatable table references</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T561</entry>
            <entry colname="col2">Holdable locators</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T571</entry>
            <entry colname="col2">Array-returning external SQL-invoked functions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T572</entry>
            <entry colname="col2">Multiset-returning external SQL-invoked functions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T581</entry>
            <entry colname="col2">Regular expression substring function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T591</entry>
            <entry colname="col2"><codeph>UNIQUE</codeph> constraints of possibly null
              columns</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T601</entry>
            <entry colname="col2">Local cursor references</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T611</entry>
            <entry colname="col2">Elementary OLAP operations</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T612</entry>
            <entry colname="col2">Advanced OLAP operations</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Partially supported</entry>
          </row>
          <row>
            <entry colname="col1">T613</entry>
            <entry colname="col2">Sampling</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T614</entry>
            <entry colname="col2"><codeph>NTILE</codeph> function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T615</entry>
            <entry colname="col2"><codeph>LEAD</codeph> and <codeph>LAG</codeph> functions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T616</entry>
            <entry colname="col2">Null treatment option for <codeph>LEAD</codeph> and
                <codeph>LAG</codeph> functions</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T617</entry>
            <entry colname="col2"><codeph>FIRST_VALUE</codeph> and <codeph>LAST_VALUE</codeph>
              function</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T618</entry>
            <entry colname="col2">
              <codeph>NTH_VALUE</codeph>
            </entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Function exists in Greenplum but not all options are
              supported</entry>
          </row>
          <row>
            <entry colname="col1">T621</entry>
            <entry colname="col2">Enhanced numeric functions</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T631</entry>
            <entry colname="col2">N predicate with one list element</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T641</entry>
            <entry colname="col2">Multiple column assignment</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">Some syntax variants supported</entry>
          </row>
          <row>
            <entry colname="col1">T651</entry>
            <entry colname="col2">SQL-schema statements in SQL routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T652</entry>
            <entry colname="col2">SQL-dynamic statements in SQL routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T653</entry>
            <entry colname="col2">SQL-schema statements in external routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T654</entry>
            <entry colname="col2">SQL-dynamic statements in external routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">T655</entry>
            <entry colname="col2">Cyclically dependent routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M001</entry>
            <entry colname="col2">Datalinks</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M002</entry>
            <entry colname="col2">Datalinks via SQL/CLI</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M003</entry>
            <entry colname="col2">Datalinks via Embedded SQL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M004</entry>
            <entry colname="col2">Foreign data support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M005</entry>
            <entry colname="col2">Foreign schema support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M006</entry>
            <entry colname="col2">GetSQLString routine</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M007</entry>
            <entry colname="col2">TransmitRequest</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M009</entry>
            <entry colname="col2">GetOpts and GetStatistics routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M010</entry>
            <entry colname="col2">Foreign data wrapper support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M011</entry>
            <entry colname="col2">Datalinks via Ada</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M012</entry>
            <entry colname="col2">Datalinks via C</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M013</entry>
            <entry colname="col2">Datalinks via COBOL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M014</entry>
            <entry colname="col2">Datalinks via Fortran</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M015</entry>
            <entry colname="col2">Datalinks via M</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M016</entry>
            <entry colname="col2">Datalinks via Pascal</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M017</entry>
            <entry colname="col2">Datalinks via PL/I</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M018</entry>
            <entry colname="col2">Foreign data wrapper interface routines in Ada</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M019</entry>
            <entry colname="col2">Foreign data wrapper interface routines in C</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M020</entry>
            <entry colname="col2">Foreign data wrapper interface routines in COBOL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M021</entry>
            <entry colname="col2">Foreign data wrapper interface routines in Fortran</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M022</entry>
            <entry colname="col2">Foreign data wrapper interface routines in MUMPS</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M023</entry>
            <entry colname="col2">Foreign data wrapper interface routines in Pascal</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M024</entry>
            <entry colname="col2">Foreign data wrapper interface routines in PL/I</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M030</entry>
            <entry colname="col2">SQL-server foreign data support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">M031</entry>
            <entry colname="col2">Foreign data wrapper general routines</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X010</entry>
            <entry colname="col2">XML type</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X011</entry>
            <entry colname="col2">Arrays of XML type</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X012</entry>
            <entry colname="col2">Multisets of XML type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X013</entry>
            <entry colname="col2">Distinct types of XML type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X014</entry>
            <entry colname="col2">Attributes of XML type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X015</entry>
            <entry colname="col2">Fields of XML type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X016</entry>
            <entry colname="col2">Persistent XML values</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X020</entry>
            <entry colname="col2">XMLConcat</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4">xmlconcat2() supported</entry>
          </row>
          <row>
            <entry colname="col1">X025</entry>
            <entry colname="col2">XMLCast</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X030</entry>
            <entry colname="col2">XMLDocument</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X031</entry>
            <entry colname="col2">XMLElement</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X032</entry>
            <entry colname="col2">XMLForest</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X034</entry>
            <entry colname="col2">XMLAgg</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X035</entry>
            <entry colname="col2">XMLAgg: ORDER BY option</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X036</entry>
            <entry colname="col2">XMLComment</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X037</entry>
            <entry colname="col2">XMLPI</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X038</entry>
            <entry colname="col2">XMLText</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X040</entry>
            <entry colname="col2">Basic table mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X041</entry>
            <entry colname="col2">Basic table mapping: nulls absent</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X042</entry>
            <entry colname="col2">Basic table mapping: null as nil</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X043</entry>
            <entry colname="col2">Basic table mapping: table as forest</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X044</entry>
            <entry colname="col2">Basic table mapping: table as element</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X045</entry>
            <entry colname="col2">Basic table mapping: with target namespace</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X046</entry>
            <entry colname="col2">Basic table mapping: data mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X047</entry>
            <entry colname="col2">Basic table mapping: metadata mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X048</entry>
            <entry colname="col2">Basic table mapping: base64 encoding of binary strings</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X049</entry>
            <entry colname="col2">Basic table mapping: hex encoding of binary strings</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X051</entry>
            <entry colname="col2">Advanced table mapping: nulls absent</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X052</entry>
            <entry colname="col2">Advanced table mapping: null as nil</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X053</entry>
            <entry colname="col2">Advanced table mapping: table as forest</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X054</entry>
            <entry colname="col2">Advanced table mapping: table as element</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X055</entry>
            <entry colname="col2">Advanced table mapping: target namespace</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X056</entry>
            <entry colname="col2">Advanced table mapping: data mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X057</entry>
            <entry colname="col2">Advanced table mapping: metadata mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X058</entry>
            <entry colname="col2">Advanced table mapping: base64 encoding of binary strings</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X059</entry>
            <entry colname="col2">Advanced table mapping: hex encoding of binary strings</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X060</entry>
            <entry colname="col2">XMLParse: Character string input and CONTENT option</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X061</entry>
            <entry colname="col2">XMLParse: Character string input and DOCUMENT option</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X065</entry>
            <entry colname="col2">XMLParse: BLOB input and CONTENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X066</entry>
            <entry colname="col2">XMLParse: BLOB input and DOCUMENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X068</entry>
            <entry colname="col2">XMLSerialize: BOM</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X069</entry>
            <entry colname="col2">XMLSerialize: INDENT</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X070</entry>
            <entry colname="col2">XMLSerialize: Character string serialization and CONTENT
              option</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X071</entry>
            <entry colname="col2">XMLSerialize: Character string serialization and DOCUMENT
              option</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X072</entry>
            <entry colname="col2">XMLSerialize: Character string serialization</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X073</entry>
            <entry colname="col2">XMLSerialize: BLOB serialization and CONTENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X074</entry>
            <entry colname="col2">XMLSerialize: BLOB serialization and DOCUMENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X075</entry>
            <entry colname="col2">XMLSerialize: BLOB serialization</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X076</entry>
            <entry colname="col2">XMLSerialize: VERSION</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X077</entry>
            <entry colname="col2">XMLSerialize: explicit ENCODING option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X078</entry>
            <entry colname="col2">XMLSerialize: explicit XML declaration</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X080</entry>
            <entry colname="col2">Namespaces in XML publishing</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X081</entry>
            <entry colname="col2">Query-level XML namespace declarations</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X082</entry>
            <entry colname="col2">XML namespace declarations in DML</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X083</entry>
            <entry colname="col2">XML namespace declarations in DDL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X084</entry>
            <entry colname="col2">XML namespace declarations in compound statements</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X085</entry>
            <entry colname="col2">Predefined namespace prefixes</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X086</entry>
            <entry colname="col2">XML namespace declarations in XMLTable</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X090</entry>
            <entry colname="col2">XML document predicate</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">xml_is_well_formed_document() supported</entry>
          </row>
          <row>
            <entry colname="col1">X091</entry>
            <entry colname="col2">XML content predicate</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">xml_is_well_formed_content() supported</entry>
          </row>
          <row>
            <entry colname="col1">X096</entry>
            <entry colname="col2">XMLExists</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4">xmlexists() supported</entry>
          </row>
          <row>
            <entry colname="col1">X100</entry>
            <entry colname="col2">Host language support for XML: CONTENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X101</entry>
            <entry colname="col2">Host language support for XML: DOCUMENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X110</entry>
            <entry colname="col2">Host language support for XML: VARCHAR mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X111</entry>
            <entry colname="col2">Host language support for XML: CLOB mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X112</entry>
            <entry colname="col2">Host language support for XML: BLOB mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X113</entry>
            <entry colname="col2">Host language support for XML: STRIP WHITESPACE option</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X114</entry>
            <entry colname="col2">Host language support for XML: PRESERVE WHITESPACE option</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X120</entry>
            <entry colname="col2">XML parameters in SQL routines</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X121</entry>
            <entry colname="col2">XML parameters in external routines</entry>
            <entry colname="col3">YES</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X131</entry>
            <entry colname="col2">Query-level XMLBINARY clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X132</entry>
            <entry colname="col2">XMLBINARY clause in DML</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X133</entry>
            <entry colname="col2">XMLBINARY clause in DDL</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X134</entry>
            <entry colname="col2">XMLBINARY clause in compound statements</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X135</entry>
            <entry colname="col2">XMLBINARY clause in subqueries</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X141</entry>
            <entry colname="col2">IS VALID predicate: data-driven case</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X142</entry>
            <entry colname="col2">IS VALID predicate: ACCORDING TO clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X143</entry>
            <entry colname="col2">IS VALID predicate: ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X144</entry>
            <entry colname="col2">IS VALID predicate: schema location</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X145</entry>
            <entry colname="col2">IS VALID predicate outside check constraints</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X151</entry>
            <entry colname="col2">IS VALID predicate with DOCUMENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X152</entry>
            <entry colname="col2">IS VALID predicate with CONTENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X153</entry>
            <entry colname="col2">IS VALID predicate with SEQUENCE option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X155</entry>
            <entry colname="col2">IS VALID predicate: NAMESPACE without ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X157</entry>
            <entry colname="col2">IS VALID predicate: NO NAMESPACE with ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X160</entry>
            <entry colname="col2">Basic Information Schema for registered XML Schemas</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X161</entry>
            <entry colname="col2">Advanced Information Schema for registered XML Schemas</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X170</entry>
            <entry colname="col2">XML null handling options</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X171</entry>
            <entry colname="col2">NIL ON NO CONTENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X181</entry>
            <entry colname="col2">XML( DOCUMENT (UNTYPED)) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X182</entry>
            <entry colname="col2">XML( DOCUMENT (ANY)) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X190</entry>
            <entry colname="col2">XML( SEQUENCE) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X191</entry>
            <entry colname="col2">XML( DOCUMENT (XMLSCHEMA )) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X192</entry>
            <entry colname="col2">XML( CONTENT (XMLSCHEMA)) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X200</entry>
            <entry colname="col2">XMLQuery</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X201</entry>
            <entry colname="col2">XMLQuery: RETURNING CONTENT</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X202</entry>
            <entry colname="col2">XMLQuery: RETURNING SEQUENCE</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X203</entry>
            <entry colname="col2">XMLQuery: passing a context item</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X204</entry>
            <entry colname="col2">XMLQuery: initializing an XQuery variable</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X205</entry>
            <entry colname="col2">XMLQuery: EMPTY ON EMPTY option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X206</entry>
            <entry colname="col2">XMLQuery: NULL ON EMPTY option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X211</entry>
            <entry colname="col2">XML 1.1 support</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X221</entry>
            <entry colname="col2">XML passing mechanism BY VALUE</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X222</entry>
            <entry colname="col2">XML passing mechanism BY REF</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X231</entry>
            <entry colname="col2">XML( CONTENT (UNTYPED )) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X232</entry>
            <entry colname="col2">XML( CONTENT (ANY )) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X241</entry>
            <entry colname="col2">RETURNING CONTENT in XML publishing</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X242</entry>
            <entry colname="col2">RETURNING SEQUENCE in XML publishing</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X251</entry>
            <entry colname="col2">Persistent XML values of XML( DOCUMENT (UNTYPED )) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X252</entry>
            <entry colname="col2">Persistent XML values of XML( DOCUMENT (ANY)) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X253</entry>
            <entry colname="col2">Persistent XML values of XML( CONTENT (UNTYPED)) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X254</entry>
            <entry colname="col2">Persistent XML values of XML( CONTENT (ANY)) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X255</entry>
            <entry colname="col2">Persistent XML values of XML( SEQUENCE) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X256</entry>
            <entry colname="col2">Persistent XML values of XML( DOCUMENT (XMLSCHEMA)) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X257</entry>
            <entry colname="col2">Persistent XML values of XML( CONTENT (XMLSCHEMA ) type</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X260</entry>
            <entry colname="col2">XML type: ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X261</entry>
            <entry colname="col2">XML type: NAMESPACE without ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X263</entry>
            <entry colname="col2">XML type: NO NAMESPACE with ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X264</entry>
            <entry colname="col2">XML type: schema location</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X271</entry>
            <entry colname="col2">XMLValidate: data-driven case</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X272</entry>
            <entry colname="col2">XMLValidate: ACCORDING TO clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X273</entry>
            <entry colname="col2">XMLValidate: ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X274</entry>
            <entry colname="col2">XMLValidate: schema location</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X281</entry>
            <entry colname="col2">XMLValidate: with DOCUMENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X282</entry>
            <entry colname="col2">XMLValidate with CONTENT option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X283</entry>
            <entry colname="col2">XMLValidate with SEQUENCE option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X284</entry>
            <entry colname="col2">XMLValidate NAMESPACE without ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X286</entry>
            <entry colname="col2">XMLValidate: NO NAMESPACE with ELEMENT clause</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X300</entry>
            <entry colname="col2">XMLTable</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X301</entry>
            <entry colname="col2">XMLTable: derived column list option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X302</entry>
            <entry colname="col2">XMLTable: ordinality column option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X303</entry>
            <entry colname="col2">XMLTable: column default option</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X304</entry>
            <entry colname="col2">XMLTable: passing a context item</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X305</entry>
            <entry colname="col2">XMLTable: initializing an XQuery variable</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
          <row>
            <entry colname="col1">X400</entry>
            <entry colname="col2">Name and identifier mapping</entry>
            <entry colname="col3">NO</entry>
            <entry colname="col4"/>
          </row>
        </tbody>
      </tgroup>
    </table>
  </body>
</topic>
